
SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `vx_api_apis`
-- ----------------------------
DROP TABLE IF EXISTS `vx_api_apis`;
CREATE TABLE `vx_api_apis` (
  `name` varchar(60) NOT NULL,
  `app_name` varchar(60) DEFAULT NULL,
  `content` text,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `vx_api_apis`
-- ----------------------------
BEGIN;
INSERT INTO `vx_api_apis` VALUES ('咨询', '微脉测试1', '{\"appName\":\"微脉测试1\",\"apiName\":\"咨询\",\"apiDescribe\":\"咨询\",\"apiCreateTime\":\"2018-11-05T10:30:44.950Z\",\"path\":\"/content/v1/news/query\",\"method\":\"ALL\",\"contentType\":\"application/json;charset=UTF-8\",\"consumes\":[\"*\"],\"apiLimit\":-1,\"ipLimit\":-1,\"passBody\":true,\"bodyAsQuery\":false,\"enterParam\":[{\"paramName\":\"pageNo\",\"position\":\"QUERY\",\"paramType\":\"String\",\"isNotNull\":true},{\"paramName\":\"pageSize\",\"position\":\"QUERY\",\"paramType\":\"String\",\"isNotNull\":true},{\"paramName\":\"start\",\"position\":\"QUERY\",\"paramType\":\"String\",\"isNotNull\":true},{\"paramName\":\"end\",\"position\":\"QUERY\",\"paramType\":\"String\",\"isNotNull\":true}],\"serverEntrance\":{\"serverType\":\"HTTP_HTTPS\",\"body\":{\"method\":\"GET\",\"balanceType\":\"POLLING_AVAILABLE\",\"serverUrls\":[{\"url\":\"http://localhost:2001/content/v1/news/query\",\"weight\":0}],\"timeOut\":30000,\"retryTime\":30000,\"params\":[{\"apiParamName\":\"pageNo\",\"apiParamPosition\":\"QUERY\",\"serParamName\":\"pageNo\",\"serParamPosition\":\"QUERY\",\"paramType\":\"String\",\"type\":0},{\"apiParamName\":\"pageSize\",\"apiParamPosition\":\"QUERY\",\"serParamName\":\"pageSize\",\"serParamPosition\":\"QUERY\",\"paramType\":\"String\",\"type\":0},{\"apiParamName\":\"start\",\"apiParamPosition\":\"QUERY\",\"serParamName\":\"start\",\"serParamPosition\":\"QUERY\",\"paramType\":\"String\",\"type\":0},{\"apiParamName\":\"end\",\"apiParamPosition\":\"QUERY\",\"serParamName\":\"end\",\"serParamPosition\":\"QUERY\",\"paramType\":\"String\",\"type\":0}]}},\"result\":{\"apiEnterCheckFailureStatus\":400,\"limitStatus\":202,\"failureStatus\":500,\"cantConnServerStatus\":504,\"limitExample\":\"\",\"apiEnterCheckFailureExample\":\"\",\"successExample\":\"\",\"failureExample\":\"\",\"cantConnServerExample\":\"\"}}'), ('微脉咨询列表接口', '微脉开放平台网关', '{\"appName\":\"微脉开放平台网关\",\"apiName\":\"微脉咨询列表接口\",\"apiDescribe\":\"微脉咨询列表接口\",\"apiCreateTime\":\"2018-11-05T06:48:18.200Z\",\"path\":\"/content/v1/news/query\",\"method\":\"GET\",\"contentType\":\"application/json;charset=UTF-8\",\"consumes\":[\"*\"],\"apiLimit\":-1,\"ipLimit\":-1,\"passBody\":true,\"bodyAsQuery\":false,\"enterParam\":[{\"paramName\":\"pageNo\",\"position\":\"QUERY\",\"paramType\":\"Integer\",\"isNotNull\":true},{\"paramName\":\"pageSize\",\"position\":\"QUERY\",\"paramType\":\"Integer\",\"isNotNull\":true},{\"paramName\":\"start\",\"position\":\"QUERY\",\"paramType\":\"Long\",\"isNotNull\":true},{\"paramName\":\"end\",\"position\":\"QUERY\",\"paramType\":\"Long\",\"isNotNull\":true}],\"serverEntrance\":{\"serverType\":\"HTTP_HTTPS\",\"body\":{\"method\":\"POST\",\"balanceType\":\"POLLING_AVAILABLE\",\"serverUrls\":[{\"url\":\"http://127.0.0.1:2001/content/v1/news/query\",\"weight\":0}],\"timeOut\":30000,\"retryTime\":30000,\"params\":[{\"apiParamName\":\"pageNo\",\"apiParamPosition\":\"QUERY\",\"serParamName\":\"pageNo\",\"serParamPosition\":\"QUERY\",\"paramType\":\"Integer\",\"type\":0},{\"apiParamName\":\"pageSize\",\"apiParamPosition\":\"QUERY\",\"serParamName\":\"pageSize\",\"serParamPosition\":\"QUERY\",\"paramType\":\"Integer\",\"type\":0},{\"apiParamName\":\"start\",\"apiParamPosition\":\"QUERY\",\"serParamName\":\"start\",\"serParamPosition\":\"QUERY\",\"paramType\":\"Long\",\"type\":0},{\"apiParamName\":\"end\",\"apiParamPosition\":\"QUERY\",\"serParamName\":\"end\",\"serParamPosition\":\"QUERY\",\"paramType\":\"Long\",\"type\":0}]}},\"result\":{\"apiEnterCheckFailureStatus\":400,\"limitStatus\":202,\"failureStatus\":500,\"cantConnServerStatus\":504,\"limitExample\":\"\",\"apiEnterCheckFailureExample\":\"{\\\"error\\\":400,\\\"erroMsg\\\":\\\"vx bad request\\\"}\",\"successExample\":\"\",\"failureExample\":\"\",\"cantConnServerExample\":\"\"}}');
COMMIT;

-- ----------------------------
--  Table structure for `vx_api_application`
-- ----------------------------
DROP TABLE IF EXISTS `vx_api_application`;
CREATE TABLE `vx_api_application` (
  `name` varchar(60) NOT NULL,
  `content` text,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
--  Records of `vx_api_application`
-- ----------------------------
BEGIN;
INSERT INTO `vx_api_application` VALUES ('微脉开放平台网关', '{\"appName\":\"微脉开放平台网关\",\"describe\":\"微脉开放平台网关\",\"contentLength\":-1,\"scope\":0,\"sessionTimeOut\":1800000,\"sessionCookieName\":\"VX-API.session\",\"decoderInitialBufferSize\":128,\"maxPoolSize\":5,\"maxInitialLineLength\":4096,\"maxHeaderSize\":100,\"keepAlive\":true,\"notFoundContentType\":\"text/html;charset=UTF-8\",\"notFoundResult\":\"not found resource\",\"blacklistIpCode\":403,\"blacklistIpContentType\":\"text/html;charset=UTF-8\",\"blacklistIpResult\":\"you can\'t access this service\",\"serverOptions\":{\"createHttp\":true,\"createHttps\":false,\"createwebSocket\":false,\"httpPort\":8330,\"httpsPort\":8430,\"webSocketPort\":8530},\"corsOptions\":{\"allowedOrigin\":\"*\",\"allowCredentials\":false,\"maxAgeSeconds\":0,\"allowedMethods\":[\"GET\",\"HEAD\",\"POST\",\"OPTIONS\"]},\"time\":\"2018-11-05T05:41:29.795Z\"}'), ('微脉测试1', '{\"appName\":\"微脉测试1\",\"describe\":\"微脉测试-8340\",\"contentLength\":-1,\"scope\":0,\"sessionTimeOut\":1800000,\"sessionCookieName\":\"VX-API.session\",\"decoderInitialBufferSize\":128,\"maxPoolSize\":5,\"maxInitialLineLength\":4096,\"maxHeaderSize\":8192,\"keepAlive\":true,\"notFoundContentType\":\"text/html;charset=UTF-8\",\"notFoundResult\":\"not found resource\",\"blacklistIpCode\":403,\"blacklistIpContentType\":\"text/html;charset=UTF-8\",\"blacklistIpResult\":\"you can\'t access this service\",\"serverOptions\":{\"createHttp\":true,\"createHttps\":false,\"createwebSocket\":false,\"httpPort\":8340,\"httpsPort\":8430,\"webSocketPort\":8530},\"corsOptions\":{\"allowedOrigin\":\"*\",\"allowCredentials\":false,\"maxAgeSeconds\":0,\"allowedMethods\":[\"GET\",\"HEAD\",\"POST\",\"PUT\",\"DELETE\"]},\"time\":\"2018-11-05T10:28:43.165Z\"}');
COMMIT;

-- ----------------------------
--  Table structure for `vx_api_blacklist`
-- ----------------------------
DROP TABLE IF EXISTS `vx_api_blacklist`;
CREATE TABLE `vx_api_blacklist` (
  `name` varchar(60) NOT NULL,
  `content` text,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

SET FOREIGN_KEY_CHECKS = 1;
